﻿CREATE TABLE [dbo].[ASMS_SettlementBillServiceItem]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[SettlementBillId] uniqueidentifier NOT NULL,
	[MaintenanceBillServiceItemId] uniqueidentifier NOT NULL,
	[ServiceItemId] uniqueidentifier NOT NULL,
	[Price] money NOT NULL,
	[Discount] money NOT NULL,
	[Hour] money NOT NULL,
	[Amount] money NOT NULL,
	[OrigAmount] money NOT NULL,
	[DisAmount] money NOT NULL,
	[TaxAmount] money NOT NULL,
	[TechCommAmount] money NOT NULL,
	[SalesCommAmount] money NOT NULL,
	[SettlementType] int NOT NULL
)
